CPPSEC3109
Use and maintain security databases and compile reports


Application

This unit specifies the skills and knowledge required to use and maintain security databases and compile reports.

It includes:

setting up hardware, software, databases and information systems

using and maintaining security databases and a broad range of database functions

monitoring and reviewing database performance and effectiveness and using feedback to implement improvements

compiling data in the required reporting format and checking accuracy, compatibility and reliability.

It applies to people working independently or under limited supervision as members of a security team.

This unit may form part of the licensing requirements for people engaged in security operations in those states and territories where these are regulated activities.


Elements and Performance Criteria

Elements describe the essential outcomes.

Performance criteria describe what needs to be done to demonstrate achievement of the element.

1. Establish security database and systems.

1.1 Review workplace procedures and policies to ensure compliance with legal rights and responsibilities when maintaining and using security databases.

1.2 Set up workstation to comply with ergonomic considerations and use work processes that conserve resources.

1.3 Use software and hardware to meet data requirements following manufacturers’ specifications.

1.4 Monitor and regularly update virus protection software to ensure continuous data integrity and protection.

1.5 Confirm data access, security and storage requirements and set up systems to ensure data security and confidentiality.

1.6 Set up and follow regular housekeeping, maintenance and back-up procedures.

1.7 Implement stand-by database and alternative strategies to address operational faults and deficiencies in database systems.

2. Use and maintain security database.

2.1 Confirm and comply with data entry, output and presentation requirements to meet work instructions.

2.2 Obtain data from verifiable sources and check for variations in data quality.

2.3 Use database functions to input verified data, check data accuracy and quality, and rectify errors.

2.4 Diagnose and report errors and lags in data processing or information discrepancies.

2.5 Identify faults requiring specialist assistance and organise repairs in consultation with relevant persons.

2.6 Monitor database performance and identify and implement measures to improve content, interfaces and effectiveness in consultation with relevant persons.

3. Compile report and improve database and systems.

3.1 Produce report in the required format, and check content to confirm accuracy and data compatibility and reliability.

3.2 Request and use feedback to improve the effectiveness and performance of database and systems.

3.3 Store and protect security data, and complete and maintain documentation with due regard to confidentiality in accordance with workplace requirements.

Foundation Skills

This section describes the language, literacy, numeracy and employment skills essential to performance in this unit but not explicit in the performance criteria:

writing skills to:

produce reports using information technology such as a computer and software

collate and present data in a logical and sequential manner

reading skills to interpret:

procedures and policies that clarify legal rights and responsibilities

manufacturers’ instructions to correctly set up hardware and database systems

security data that may be technical and numerical in nature, such as database formulae and queries

speaking and listening skills to:

use questions and active listening to clarify and discuss system faults

use paraphrasing to check understanding when receiving spoken feedback to improve systems

numeracy skills to:

interpret and calculate statistical information

use simple mathematical formulae within databases

problem solving skills to:

verify the accuracy of security data

recognise variations in data quality

troubleshoot system problems and identify faults

technology skills to:

use a range of common information technologies to access, store, study, retrieve, transmit and manipulate data and information, for example computer and software packages involving spreadsheets

type and use a keyboard to enter data.


Sectors

Security operations